package org.bonorsoft.modules.wechat.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import org.bonorsoft.modules.wechat.entity.WxResponse;

import java.util.List;

public interface WxResponseMapper extends BaseMapper<WxResponse> {

    @Select("select hfid, qqid, hfnr, hfrid, hfrxm, hfsj " +
            "from hy_hf where qqid = #{qqid}")
    List<WxResponse> getWxResponseByQqid(String qqid);

    @Delete("delete from hy_hf " +
            "where qqid = #{qqid}")
    void removeByQqid(String qqid);
}
